﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TKCNDataSet" targetNamespace="http://tempuri.org/TKCNDataSet.xsd" xmlns:mstns="http://tempuri.org/TKCNDataSet.xsd" xmlns="http://tempuri.org/TKCNDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="TKCNConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TKCNConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TKCCLD.Properties.Settings.GlobalReference.Default.TKCNConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SanPhamNewTableAdapter" GeneratorDataComponentClassName="SanPhamNewTableAdapter" Name="SanPhamNew" UserDataComponentName="SanPhamNewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TKCNConnectionString (Settings)" DbObjectName="TKCN.dbo.SanPhamNew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SanPhamNew] WHERE (([MaChungLoaiSanPham] = @Original_MaChungLoaiSanPham) AND ([MaSanPham] = @Original_MaSanPham) AND ((@IsNull_TenSanPham = 1 AND [TenSanPham] IS NULL) OR ([TenSanPham] = @Original_TenSanPham)) AND ((@IsNull_Phot = 1 AND [Phot] IS NULL) OR ([Phot] = @Original_Phot)) AND ((@IsNull_De = 1 AND [De] IS NULL) OR ([De] = @Original_De)) AND ((@IsNull_CoSo = 1 AND [CoSo] IS NULL) OR ([CoSo] = @Original_CoSo)) AND ((@IsNull_Last = 1 AND [Last] IS NULL) OR ([Last] = @Original_Last)) AND ((@IsNull_RapMai = 1 AND [RapMai] IS NULL) OR ([RapMai] = @Original_RapMai)) AND ((@IsNull_BanhMai = 1 AND [BanhMai] IS NULL) OR ([BanhMai] = @Original_BanhMai)) AND ((@IsNull_Quai = 1 AND [Quai] IS NULL) OR ([Quai] = @Original_Quai)) AND ((@IsNull_KhuonMat = 1 AND [KhuonMat] IS NULL) OR ([KhuonMat] = @Original_KhuonMat)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaChungLoaiSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChungLoaiSanPham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSanPham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenSanPham" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenSanPham" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenSanPham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phot" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phot" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phot" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_De" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_De" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoSo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Last" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Last" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Last" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Last" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RapMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RapMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RapMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RapMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BanhMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BanhMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BanhMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BanhMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Quai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Quai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Quai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KhuonMat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhuonMat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KhuonMat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KhuonMat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SanPhamNew] ([MaChungLoaiSanPham], [MaSanPham], [TenSanPham], [Phot], [De], [CoSo], [Last], [RapMai], [BanhMai], [Quai], [KhuonMat], [GhiChu]) VALUES (@MaChungLoaiSanPham, @MaSanPham, @TenSanPham, @Phot, @De, @CoSo, @Last, @RapMai, @BanhMai, @Quai, @KhuonMat, @GhiChu);
SELECT MaChungLoaiSanPham, MaSanPham, TenSanPham, Phot, De, CoSo, Last, RapMai, BanhMai, Quai, KhuonMat, GhiChu FROM SanPhamNew WHERE (MaSanPham = @MaSanPham)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaChungLoaiSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChungLoaiSanPham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSanPham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenSanPham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phot" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phot" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@De" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Last" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Last" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RapMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RapMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BanhMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BanhMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Quai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Quai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KhuonMat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KhuonMat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaChungLoaiSanPham, MaSanPham, TenSanPham, Phot, De, CoSo, Last, RapMai, BanhMai, Quai, KhuonMat, GhiChu FROM dbo.SanPhamNew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SanPhamNew] SET [MaChungLoaiSanPham] = @MaChungLoaiSanPham, [MaSanPham] = @MaSanPham, [TenSanPham] = @TenSanPham, [Phot] = @Phot, [De] = @De, [CoSo] = @CoSo, [Last] = @Last, [RapMai] = @RapMai, [BanhMai] = @BanhMai, [Quai] = @Quai, [KhuonMat] = @KhuonMat, [GhiChu] = @GhiChu WHERE (([MaChungLoaiSanPham] = @Original_MaChungLoaiSanPham) AND ([MaSanPham] = @Original_MaSanPham) AND ((@IsNull_TenSanPham = 1 AND [TenSanPham] IS NULL) OR ([TenSanPham] = @Original_TenSanPham)) AND ((@IsNull_Phot = 1 AND [Phot] IS NULL) OR ([Phot] = @Original_Phot)) AND ((@IsNull_De = 1 AND [De] IS NULL) OR ([De] = @Original_De)) AND ((@IsNull_CoSo = 1 AND [CoSo] IS NULL) OR ([CoSo] = @Original_CoSo)) AND ((@IsNull_Last = 1 AND [Last] IS NULL) OR ([Last] = @Original_Last)) AND ((@IsNull_RapMai = 1 AND [RapMai] IS NULL) OR ([RapMai] = @Original_RapMai)) AND ((@IsNull_BanhMai = 1 AND [BanhMai] IS NULL) OR ([BanhMai] = @Original_BanhMai)) AND ((@IsNull_Quai = 1 AND [Quai] IS NULL) OR ([Quai] = @Original_Quai)) AND ((@IsNull_KhuonMat = 1 AND [KhuonMat] IS NULL) OR ([KhuonMat] = @Original_KhuonMat)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)));
SELECT MaChungLoaiSanPham, MaSanPham, TenSanPham, Phot, De, CoSo, Last, RapMai, BanhMai, Quai, KhuonMat, GhiChu FROM SanPhamNew WHERE (MaSanPham = @MaSanPham)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaChungLoaiSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChungLoaiSanPham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSanPham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenSanPham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phot" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phot" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@De" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoSo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Last" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Last" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RapMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RapMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BanhMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BanhMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Quai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Quai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KhuonMat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KhuonMat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaChungLoaiSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaChungLoaiSanPham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSanPham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenSanPham" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenSanPham" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenSanPham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenSanPham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phot" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phot" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phot" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phot" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_De" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_De" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CoSo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoSo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CoSo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CoSo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Last" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Last" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Last" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Last" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RapMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RapMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RapMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RapMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BanhMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BanhMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BanhMai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BanhMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Quai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Quai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Quai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KhuonMat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhuonMat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KhuonMat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KhuonMat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaChungLoaiSanPham" DataSetColumn="MaChungLoaiSanPham" />
              <Mapping SourceColumn="MaSanPham" DataSetColumn="MaSanPham" />
              <Mapping SourceColumn="TenSanPham" DataSetColumn="TenSanPham" />
              <Mapping SourceColumn="Phot" DataSetColumn="Phot" />
              <Mapping SourceColumn="De" DataSetColumn="De" />
              <Mapping SourceColumn="CoSo" DataSetColumn="CoSo" />
              <Mapping SourceColumn="Last" DataSetColumn="Last" />
              <Mapping SourceColumn="RapMai" DataSetColumn="RapMai" />
              <Mapping SourceColumn="BanhMai" DataSetColumn="BanhMai" />
              <Mapping SourceColumn="Quai" DataSetColumn="Quai" />
              <Mapping SourceColumn="KhuonMat" DataSetColumn="KhuonMat" />
              <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TKCNDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="TKCNDataSet" msprop:Generator_UserDSName="TKCNDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SanPhamNew" msprop:Generator_UserTableName="SanPhamNew" msprop:Generator_RowDeletedName="SanPhamNewRowDeleted" msprop:Generator_TableClassName="SanPhamNewDataTable" msprop:Generator_RowChangedName="SanPhamNewRowChanged" msprop:Generator_RowClassName="SanPhamNewRow" msprop:Generator_RowChangingName="SanPhamNewRowChanging" msprop:Generator_RowEvArgName="SanPhamNewRowChangeEvent" msprop:Generator_RowEvHandlerName="SanPhamNewRowChangeEventHandler" msprop:Generator_TablePropName="SanPhamNew" msprop:Generator_TableVarName="tableSanPhamNew" msprop:Generator_RowDeletingName="SanPhamNewRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaChungLoaiSanPham" msprop:Generator_UserColumnName="MaChungLoaiSanPham" msprop:Generator_ColumnPropNameInRow="MaChungLoaiSanPham" msprop:Generator_ColumnVarNameInTable="columnMaChungLoaiSanPham" msprop:Generator_ColumnPropNameInTable="MaChungLoaiSanPhamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaSanPham" msprop:Generator_UserColumnName="MaSanPham" msprop:Generator_ColumnPropNameInRow="MaSanPham" msprop:Generator_ColumnVarNameInTable="columnMaSanPham" msprop:Generator_ColumnPropNameInTable="MaSanPhamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenSanPham" msprop:Generator_UserColumnName="TenSanPham" msprop:Generator_ColumnPropNameInRow="TenSanPham" msprop:Generator_ColumnVarNameInTable="columnTenSanPham" msprop:Generator_ColumnPropNameInTable="TenSanPhamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phot" msprop:Generator_UserColumnName="Phot" msprop:Generator_ColumnPropNameInRow="Phot" msprop:Generator_ColumnVarNameInTable="columnPhot" msprop:Generator_ColumnPropNameInTable="PhotColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="De" msprop:Generator_UserColumnName="De" msprop:Generator_ColumnPropNameInRow="De" msprop:Generator_ColumnVarNameInTable="columnDe" msprop:Generator_ColumnPropNameInTable="DeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CoSo" msprop:Generator_UserColumnName="CoSo" msprop:Generator_ColumnPropNameInRow="CoSo" msprop:Generator_ColumnVarNameInTable="columnCoSo" msprop:Generator_ColumnPropNameInTable="CoSoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last" msprop:Generator_UserColumnName="Last" msprop:Generator_ColumnPropNameInRow="Last" msprop:Generator_ColumnVarNameInTable="columnLast" msprop:Generator_ColumnPropNameInTable="LastColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RapMai" msprop:Generator_UserColumnName="RapMai" msprop:Generator_ColumnPropNameInRow="RapMai" msprop:Generator_ColumnVarNameInTable="columnRapMai" msprop:Generator_ColumnPropNameInTable="RapMaiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BanhMai" msprop:Generator_UserColumnName="BanhMai" msprop:Generator_ColumnPropNameInRow="BanhMai" msprop:Generator_ColumnVarNameInTable="columnBanhMai" msprop:Generator_ColumnPropNameInTable="BanhMaiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quai" msprop:Generator_UserColumnName="Quai" msprop:Generator_ColumnPropNameInRow="Quai" msprop:Generator_ColumnVarNameInTable="columnQuai" msprop:Generator_ColumnPropNameInTable="QuaiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KhuonMat" msprop:Generator_UserColumnName="KhuonMat" msprop:Generator_ColumnPropNameInRow="KhuonMat" msprop:Generator_ColumnVarNameInTable="columnKhuonMat" msprop:Generator_ColumnPropNameInTable="KhuonMatColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SanPhamNew" />
      <xs:field xpath="mstns:MaSanPham" />
    </xs:unique>
  </xs:element>
</xs:schema>